pp108 : Downloading Database Scripts

Downloading Database Scripts
When the model containing data stores is published, certain database scripts are run on the actual database of the data store. While designing the MDM model, if the  Download Database Scripts option is enabled in the Data Store property, then these scripts will not be executed on the database automatically, and are saved in a file. A Database Administrator (DBA) can download the scripts, review them, and execute them manually on the database. This is useful when you want to control each and every alteration made to the database.
  1. On  CUSP  >  My Applications , click   ( MDM Admin Settings ). The  MDM Admin Settings  window appears.
  2. Select Download Database Script. A page with Download Database Script is displayed, and a table with the Model Key and Script Type columns is displayed. The models are listed in the Model Key column. Based on the MDM model state, the Script Type can be Publish or Unpublish. 

Note:

  • When the models are published, then scripts of the type Publish are available for download to be executed on the database.
  • When the models are unpublished, then scripts of the type Unpublish are available for Download to be executed on the database.

The model database scripts are downloaded. The downloaded scripts are available as a .zip file. You can save the files in a specified location or view them.

Note:

  • To delete the model scripts if they are no longer required, click   (Delete) on the toolbar.
  • To retrieve the latest changes to the scripts, click (Refresh) on the toolbar.